package LawsonTransformJava.data;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;

public class TblEmpCodes {
	
	public int		company		=0;
	public String 	r_type		=null;
	public int		emp_app		=0;
	public int		employee	=0;
	public String	code		=null;
	public String	subject		=null;
	public int		seq_nbr		=0;
	public Date		date_acquired	=null;
	public Date		renew_date	=null;
	public float 	per_rating	=0;
	public String	instructor	=null;
	public String	co_sponsored	=null;
	public String	in_pro_flag	=null;
	public String	lic_number	=null;
	public float	cost		=0;
	public String	renewal_code	=null;
	public int		component	=0;
	public float	prop_value	=0;
	public String	pa_asset_nbr	=null;
	public Date		date_returned	=null;
	public String	verified_flag	=null;
	public int		priority_code	=0;
	public String	skill_source	=null;
	public String	profic_level	=null;
	public int		obj_id		=0;
	public String	currency_code	=null;
	public int		curr_nd		=0;
	public float	base_amount	=0;
	public String	base_currency	=null;
	public int		base_nd		=0;
	public Date		date_stamp	=null;
	public int		time_stamp	=0;
	public String	user_id		=null;
	public String	state		=null;
	public String	description	=null;
	public String	l_index		=null;
	public String	epcset3_ss_sw	=null;
	public String	epcset4_ss_sw	=null;
	public String	epcset5_ss_sw	=null;
	public String	epcset6_ss_sw	=null;
	public String	epcset7_ss_sw	=null;
	public String	l_atepc_ss_sw	=null;
	
	private DateFormat df = new SimpleDateFormat("MM/dd/yyyy");
	private DateFormat df2 = new SimpleDateFormat("yyyyMMdd");
	private String text; 
	
	public void setCompany(int company) {
		this.company = company;
	}
	public void setR_type(String r_type) {
		this.r_type = r_type;
	}
	public void setEmp_app(int emp_app) {
		this.emp_app = emp_app;
	}
	public void setEmployee(int employee) {
		this.employee = employee;
	}
	public void setCode(String code) {
		this.code = code;
	}
	public void setSubject(String subject) {
		this.subject = subject;
	}
	public void setSeq_nbr(int seq_nbr) {
		this.seq_nbr = seq_nbr;
	}
	public void setDate_acquired(Date date_acquired) {
		this.date_acquired = date_acquired;
	}
	public void setRenew_date(Date renew_date) {
		this.renew_date = renew_date;
	}
	public void setPer_rating(float per_rating) {
		this.per_rating = per_rating;
	}
	public void setInstructor(String instructor) {
		this.instructor = instructor;
	}
	public void setCo_sponsored(String co_sponsored) {
		this.co_sponsored = co_sponsored;
	}
	public void setIn_pro_flag(String in_pro_flag) {
		this.in_pro_flag = in_pro_flag;
	}
	public void setLic_number(String lic_number) {
		this.lic_number = lic_number;
	}
	public void setCost(float cost) {
		this.cost = cost;
	}
	public void setRenewal_code(String renewal_code) {
		this.renewal_code = renewal_code;
	}
	public void setComponent(int component) {
		this.component = component;
	}
	public void setProp_value(float prop_value) {
		this.prop_value = prop_value;
	}
	public void setPa_asset_nbr(String pa_asset_nbr) {
		this.pa_asset_nbr = pa_asset_nbr;
	}
	public void setDate_returned(Date date_returned) {
		this.date_returned = date_returned;
	}
	public void setVerified_flag(String verified_flag) {
		this.verified_flag = verified_flag;
	}
	public void setPriority_code(int priority_code) {
		this.priority_code = priority_code;
	}
	public void setSkill_source(String skill_source) {
		this.skill_source = skill_source;
	}
	public void setProfic_level(String profic_level) {
		this.profic_level = profic_level;
	}
	public void setObj_id(int obj_id) {
		this.obj_id = obj_id;
	}
	public void setCurrency_code(String currency_code) {
		this.currency_code = currency_code;
	}
	public void setCurr_nd(int curr_nd) {
		this.curr_nd = curr_nd;
	}
	public void setBase_amount(float base_amount) {
		this.base_amount = base_amount;
	}
	public void setBase_currency(String base_currency) {
		this.base_currency = base_currency;
	}
	public void setBase_nd(int base_nd) {
		this.base_nd = base_nd;
	}
	public void setDate_stamp(Date date_stamp) {
		this.date_stamp = date_stamp;
	}
	public void setTime_stamp(int time_stamp) {
		this.time_stamp = time_stamp;
	}
	public void setUser_id(String user_id) {
		this.user_id = user_id;
	}
	public void setState(String state) {
		this.state = state;
	}
	public void setDescription(String description) {
		this.description = description;
	}
	public void setL_index(String l_index) {
		this.l_index = l_index;
	}
	public void setEpcset3_ss_sw(String epcset3_ss_sw) {
		this.epcset3_ss_sw = epcset3_ss_sw;
	}
	public void setEpcset4_ss_sw(String epcset4_ss_sw) {
		this.epcset4_ss_sw = epcset4_ss_sw;
	}
	public void setEpcset5_ss_sw(String epcset5_ss_sw) {
		this.epcset5_ss_sw = epcset5_ss_sw;
	}
	public void setEpcset6_ss_sw(String epcset6_ss_sw) {
		this.epcset6_ss_sw = epcset6_ss_sw;
	}
	public void setEpcset7_ss_sw(String epcset7_ss_sw) {
		this.epcset7_ss_sw = epcset7_ss_sw;
	}
	public void setL_atepc_ss_sw(String l_atepc_ss_sw) {
		this.l_atepc_ss_sw = l_atepc_ss_sw;
	}
	
// Getters	
	
	public int getCompany() {
		return company;
	}
	public String getR_type() {
		if (r_type==null||r_type.equals(""))
		{text = "";}
	else
		{text = "\""+r_type+"\"";}
	return text;			
	}
	public int getEmp_app() {
		return emp_app;
	}
	public int getEmployee() {
		if (emp_app == 0)
			return employee;
		return 0;
	}
	public int getApplicant() {
		if (emp_app == 1)
			return employee;
		return 0;
	}
	public String getCode() {
		if (code==null||code.equals(""))
		{text = "";}
	else
		{text = "\""+code+"\"";}
	return text;			
	}
	public String getSubject() {
		if (subject==null||subject.equals(""))
		{text = "";}
	else
		{text = "\""+subject+"\"";}
	return text;			
	}
	public int getSeq_nbr() {
		return seq_nbr;
	}
	public String getDate_acquired() {
		if (date_acquired==null)
		{text = "";}
		else
		{String date =(date_acquired!=null?df2.format(date_acquired).toString():""); 
		if (date.equals("17000101"))
			{text = "";}
		else
			{text ="\"" + df.format(date_acquired).toString() + "\"";;}}
		return text;			
				
	}
	public String getRenew_date() {
		if (renew_date==null)
		{text = "";}
		else
		{String date =(renew_date!=null?df2.format(renew_date).toString():""); 
		if (date.equals("17000101"))
			{text = "";}
		else
			{text ="\"" + df.format(renew_date).toString() + "\"";;}}
		return text;	
	}
	public float getPer_rating() {
		return per_rating;
	}
	public String getInstructor() {
		if (instructor==null||instructor.equals(""))
		{text = "";}
	else
		{text = "\""+instructor+"\"";}
	return text;			
	}
	public String getCo_sponsored() {
		if (co_sponsored==null||co_sponsored.equals(""))
		{text = "";}
	else
		{text = "\""+co_sponsored+"\"";}
	return text;				
	}
	public String getIn_pro_flag() {
		if (in_pro_flag==null||in_pro_flag.equals(""))
		{text = "";}
	else
		{text = "\""+in_pro_flag+"\"";}
	return text;			
	}
	public String getLic_number() {
		if (lic_number==null||lic_number.equals(""))
		{text = "";}
	else
		{text = "\""+lic_number+"\"";}
	return text;				
	}
	public float getCost() {
		return cost;
	}
	public String getRenewal_code() {
		if (renewal_code==null||renewal_code.equals(""))
		{text = "";}
	else
		{text = "\""+renewal_code+"\"";}
	return text;			
	}
	public int getComponent() {
		return component;
	}
	public float getProp_value() {
		return prop_value;
	}
	public String getPa_asset_nbr() {
		if (pa_asset_nbr==null||pa_asset_nbr.equals(""))
		{text = "";}
	else
		{text = "\""+pa_asset_nbr+"\"";}
	return text;			
	}
	public String getDate_returned() {
		if (date_returned==null)
		{text = "";}
		else
		{String date =(date_returned!=null?df2.format(date_returned).toString():""); 
		if (date.equals("17000101"))
			{text = "";}
		else
			{text ="\"" + df.format(date_returned).toString() + "\"";;}}
		return text;
	}
	public String getVerified_flag() {
		if (verified_flag==null||verified_flag.equals(""))
		{text = "";}
	else
		{text = "\""+verified_flag+"\"";}
	return text;		
	}
	public int getPriority_code() {
		return priority_code;
	}
	public String getSkill_source() {
		if (skill_source==null||skill_source.equals(""))
		{text = "";}
	else
		{text = "\""+skill_source+"\"";}
	return text;				
	}
	public String getProfic_level() {
		if (profic_level==null||profic_level.equals(""))
		{text = "";}
	else
		{text = "\""+profic_level+"\"";}
	return text;			
	}
	public int getObj_id() {
		return obj_id;
	}
	public String getCurrency_code() {
		if (currency_code==null||currency_code.equals(""))
		{text = "";}
	else
		{text = "\""+currency_code+"\"";}
	return text;			
	}
	public int getCurr_nd() {
		return curr_nd;
	}
	public float getBase_amount() {
		return base_amount;
	}
	public String getBase_currency() {
		if (base_currency==null||base_currency.equals(""))
		{text = "";}
	else
		{text = "\""+base_currency+"\"";}
	return text;			
	}
	public int getBase_nd() {
		return base_nd;
	}
	public String getDate_stamp() {
		if (date_stamp==null)
		{text = "";}
		else
		{String date =(date_stamp!=null?df2.format(date_stamp).toString():""); 
		if (date.equals("17000101"))
			{text = "";}
		else
			{text ="\"" + df.format(date_stamp).toString() + "\"";;}}
		return text;
	}
	public int getTime_stamp() {
		return time_stamp;
	}
	public String getUser_id() {
		if (user_id==null||user_id.equals(""))
		{text = "";}
	else
		{text = "\""+user_id+"\"";}
	return text;			
	}
	public String getState() {
		if (state==null||state.equals(""))
		{text = "";}
	else
		{text = "\""+state+"\"";}
	return text;			
	}
	public String getDescription() {
		if (description==null||description.equals(""))
		{text = "";}
	else
		{text = "\""+description+"\"";}
	return text;			
	}
	public String getL_index() {
		if (l_index==null||l_index.equals(""))
		{text = "";}
	else
		{text = "\""+l_index+"\"";}
	return text;		
	}
	public String getEpcset3_ss_sw() {
		if (epcset3_ss_sw==null||epcset3_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+epcset3_ss_sw+"\"";}
	return text;				
	}
	public String getEpcset4_ss_sw() {
		if (epcset4_ss_sw==null||epcset4_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+epcset4_ss_sw+"\"";}
	return text;		
	}
	public String getEpcset5_ss_sw() {
		if (epcset5_ss_sw==null||epcset5_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+epcset5_ss_sw+"\"";}
	return text;		
	}
	public String getEpcset6_ss_sw() {
		if (epcset6_ss_sw==null||epcset6_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+epcset6_ss_sw+"\"";}
	return text;		
	}
	public String getEpcset7_ss_sw() {
		if (epcset7_ss_sw==null||epcset7_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+epcset7_ss_sw+"\"";}
	return text;		
	}
	public String getL_atepc_ss_sw() {
		if (l_atepc_ss_sw==null||l_atepc_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+l_atepc_ss_sw+"\"";}
	return text;			
	}
	 
	
}
